home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog 125
/
Freelog_MarsAvril2015_No125.iso
/
ViePratique
/
maxicompte
/
maxicompte.exe
/
{app}
/
Update
/
dbUpdateScript
Wrap
Text File
|
2012-03-11
|
6KB
|
130 lines
//---------------------------------------------------------------------------
//
// SCRIPT DE MISE A JOUR DE LA BASE DE DONNEES
//
//---------------------------------------------------------------------------
//***************************************************************************
// INDEX
//***************************************************************************
// (05/02/2011)
NotIndexExist(BANKACCOUNT_Id_File)
SqlExe{CREATE INDEX [BANKACCOUNT_Id_File] ON [BANKACCOUNT] ([Id_File])}
End
NotIndexExist(BANKSCHEDULE_Id_File)
SqlExe{CREATE INDEX [BANKSCHEDULE_Id_File] ON [BANKSCHEDULE] ([Id_File])}
End
NotIndexExist(BANKSCHEDULE_Id_Bank)
SqlExe{CREATE INDEX [BANKSCHEDULE_Id_Bank] ON [BANKSCHEDULE] ([Id_Bank])}
End
NotIndexExist(BANKSCHEDULE_Id_Item)
SqlExe{CREATE INDEX [BANKSCHEDULE_Id_Item] ON [BANKSCHEDULE] ([Id_Item])}
End
NotIndexExist(BANKITEM_Id_File)
SqlExe{CREATE INDEX [BANKITEM_Id_File] ON [BANKITEM] ([Id_File])}
End
NotIndexExist(BANKITEM_Id_Item)
SqlExe{CREATE INDEX [BANKITEM_Id_Item] ON [BANKITEM] ([Id_Item])}
End
NotIndexExist(BANKITEMBUDGET_Id_File)
SqlExe{CREATE INDEX [BANKITEMBUDGET_Id_File] ON [BANKITEMBUDGET] ([Id_File])}
End
NotIndexExist(BANKITEMBUDGET_Id_Item)
SqlExe{CREATE INDEX [BANKITEMBUDGET_Id_Item] ON [BANKITEMBUDGET] ([Id_Item])}
End
NotIndexExist(BANKOPERATIONITEM_Id_File)
SqlExe{CREATE INDEX [BANKOPERATIONITEM_Id_File] ON [BANKOPERATIONITEM] ([Id_File])}
End
NotIndexExist(BANKOPERATIONITEM_Id_Operation)
SqlExe{CREATE INDEX [BANKOPERATIONITEM_Id_Operation] ON [BANKOPERATIONITEM] ([Id_Operation])}
End
NotIndexExist(BANKOPERATIONITEM_Id_Item)
SqlExe{CREATE INDEX [BANKOPERATIONITEM_Id_Item] ON [BANKOPERATIONITEM] ([Id_Item])}
End
NotIndexExist(BANKORDER_Id_File)
SqlExe{CREATE INDEX [BANKORDER_Id_File] ON [BANKORDER] ([Id_File])}
End
NotIndexExist(BANKORDER_Id_Bank)
SqlExe{CREATE INDEX [BANKORDER_Id_Bank] ON [BANKORDER] ([Id_Bank])}
End
NotIndexExist(BANKORDER_Id_Item)
SqlExe{CREATE INDEX [BANKORDER_Id_Item] ON [BANKORDER] ([Id_Item])}
End
NotIndexExist(BANKORDER_Id_Order)
SqlExe{CREATE INDEX [BANKORDER_Id_Order] ON [BANKORDER] ([Id_Order])}
End
NotIndexExist(BANKOPERATION_Id_File)
SqlExe{CREATE INDEX [BANKOPERATION_Id_File] ON [BANKOPERATION] ([Id_File])}
End
NotIndexExist(BANKOPERATION_Id_Bank)
SqlExe{CREATE INDEX [BANKOPERATION_Id_Bank] ON [BANKOPERATION] ([Id_Bank])}
End
NotIndexExist(BANKOPERATION_Id_Order)
SqlExe{CREATE INDEX [BANKOPERATION_Id_Order] ON [BANKOPERATION] ([Id_Order])}
End
NotIndexExist(BANKOPERATION_Balance)
SqlExe{CREATE INDEX [BANKOPERATION_Balance] ON [BANKOPERATION] ([Balance])}
End
NotIndexExist(BANKOPERATION_OperationTitle)
SqlExe{CREATE INDEX [BANKOPERATION_OperationTitle] ON [BANKOPERATION] ([OperationTitle])}
End
NotIndexExist(BANKOPERATION_OperationDate)
SqlExe{CREATE INDEX [BANKOPERATION_OperationDate] ON [BANKOPERATION] ([OperationDate])}
End
NotIndexExist(BANKOPERATION_OperationType)
SqlExe{CREATE INDEX [BANKOPERATION_OperationType] ON [BANKOPERATION] ([OperationType])}
End
NotIndexExist(BANKOPERATION_OperationRef)
SqlExe{CREATE INDEX [BANKOPERATION_OperationRef] ON [BANKOPERATION] ([OperationRef])}
End
NotIndexExist(BANKOPERATION_OperationAmount)
SqlExe{CREATE INDEX [BANKOPERATION_OperationAmount] ON [BANKOPERATION] ([OperationAmount])}
End
NotIndexExist(BANKOPERATION_Checked)
SqlExe{CREATE INDEX [BANKOPERATION_Checked] ON [BANKOPERATION] ([Checked])}
End
NotIndexExist(BANKOPERATION_CheckedDate)
SqlExe{CREATE INDEX [BANKOPERATION_CheckedDate] ON [BANKOPERATION] ([CheckedDate])}
End
//***************************************************************************
// TABLE DES FILTRES DES OPERATIONS
//***************************************************************************
//CrΘation de la table
NotTableExist(BANKOPERATIONFILTER)
SqlExe{CREATE TABLE [BANKOPERATIONFILTER] ([Id] INTEGER PRIMARY KEY AUTOINCREMENT, [Id_File] INTEGER, [Id_Bank] INTEGER)}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [Add_Date] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [Mod_Date] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [FilterYear] INTEGER}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationDate] BOOLEAN}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationDateBegin] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationDateEnd] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationCheckedDate] BOOLEAN}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationCheckedDateBegin] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationCheckedDateEnd] DATETIME}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationTitle] TEXT(255)}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationReference] TEXT(255)}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationType] TEXT(255)}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationItemId] INTEGER}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationAmount] BOOLEAN}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationMinAmount] FLOAT}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationMaxAmount] FLOAT}
SqlExe{ALTER TABLE [BANKOPERATIONFILTER] ADD [OperationState] INTEGER}
SqlExe{CREATE INDEX [BANKOPERATIONFILTER_Id_File] ON [BANKOPERATIONFILTER] ([Id_File])}
SqlExe{CREATE INDEX [BANKOPERATIONFILTER_Id_Bank] ON [BANKOPERATIONFILTER] ([Id_Bank])}
SqlExe{CREATE INDEX [BANKOPERATIONFILTER_FilterYear] ON [BANKOPERATIONFILTER] ([FilterYear])}
End
//***************************************************************************
// CORRECTION
//***************************************************************************
//Suppression des pointages "null"
SqlExe{UPDATE [BANKOPERATION] SET [Checked]=0 WHERE [Checked] is null}
//Pointage des soldes non pointΘs
SqlExe{UPDATE [BANKOPERATION] SET [Checked]=1 WHERE [Checked]=0 AND [Balance]=1}
//Suppression des postes sans position ou sans niveau (01/12/2011)
SqlExe{DELETE FROM BANKITEM WHERE [BANKITEM].[Level] is null OR [BANKITEM].[Pos] is null}